You are here: Available Utilities > A > ARCRET > Examples > ODBC/SQL Server Changes

ODBC/SQL Server Changes

Make these changes. Options not listed remain the same as those in the standard ArcRet control group from DMS1. For SQL, you must change the CARData column from the default VARCHAR to a BLOB. You must also have a special restart table DFD to change the LASTRECORD column VARCHAR length.

< DBHandler:ODBC >

  CreateTable = Yes

  CreateIndex = No

  InstallMod = sqw32

  InstallFunc = SQInstallHandler

  UserID = sa

  Passwd =

  Server = MS SQL FSINTSRV07

< DBTable:CATALOG >

  DBHandler = ODBC

  UniqueTag = catalogID

< DBTable:APPIDX >

  DBHandler = ODBC

< DBTable:ARCHIVE >

  DBHandler = ODBC

  UniqueTag = arckey

< DBTable:RESTART >

  DBHandler = ODBC

< Archival >

  ArchiveMem = Yes

< ArcRet >

  RestartTable = Restart

  CARFileDFD = carfile.dfd

  RestartDFD = restart.dfd